// 配送区域
const {DataTypes, db } = require("../db");
db.define('pythonTaskToday', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
    username:{type: DataTypes.STRING(20),comment:'用户名'},
    ym:{type: DataTypes.STRING(20),comment:'开始日期'},
    buCode:{type: DataTypes.STRING(20),comment:'终端编码'},
    buName:{type: DataTypes.STRING(20),comment:'终端名称'},
    invCode:{type: DataTypes.STRING(20),comment:'商品编码'},
    invName:{type: DataTypes.STRING(20),comment:'商品名称'},
    price:{type: DataTypes.STRING(20),comment:'价格'},
    qty:{type: DataTypes.STRING(20),comment:'数量',defaultValue:0},
    remark:{type: DataTypes.STRING(255),comment:'备注'},
    taskId:{type: DataTypes.INTEGER,comment:'数量完成',defaultValue:0},
    billNo:{type: DataTypes.STRING(255),comment:'备注'},
    saved:{type: DataTypes.INTEGER,comment:'是否保存',defaultValue:0},
    kind:{type: DataTypes.STRING,comment:'类型 send,terType1,terType2,qty',defaultValue:0},
    ct:{type: DataTypes.STRING(20),comment:'状态',defaultValue:'正常'},

}, {
    tableName: 'python_task_today',
    timestamps: false,
    comment: '今日分配任务'
});